package ref;

public class Insert2Ora {

	private static String fileName = "OTC化学药品说明书范本";//"OTC中药说明书范本";
	private static String htmlPath = "I:/data/CHD/tender/output/药监局/"+ fileName +".xlsx";//the path of excel file
//	private static final String ORACLE_URL = "jdbc:oracle:thin:@localhost:1521:XE";
//	private static final String USERNAME = "yun";
//	private static final String PASSWORD = "yun";
	private static final String ORACLE_URL = "jdbc:oracle:thin:@120.31.128.17:1521:orcl";//"jdbc:oracle:thin:@192.168.0.106:1521:orcl";
	private static final String USERNAME = "dev";
	private static final String PASSWORD = "dev2013_ora17";
	
	public static void main(String[] args) {
		OracleConn instance = new OracleConn(htmlPath,ORACLE_URL,USERNAME,PASSWORD);
		
//		instance.setHandle(new ZhongYaoBaoHu());//��ҩ����Ʒ��
//		instance.setHandle(new QiXieBiaoZhun());//��е��׼Ŀ¼
//		instance.setHandle(new QiXieFenLei());//��е����Ŀ¼
//		instance.setHandle(new OTCchinesemedicine());
		instance.setHandle(new OTCchemistry());
//		instance.setHandle(new LogoutImport());//ע�������׼�ĺŽ��ҩƷ
//		instance.setHandle(new DemostictHealth());//���ʳƷ
//		instance.setHandle(new DomesticCosmetic());//���ױƷ		
//		instance.setHandle(new DomesticTradeMed());//���ҩƷ��Ʒ��
//		instance.setHandle(new ImportHealth());//��ڱ���ʳƷ
//		instance.setHandle(new ImportMed());//���ҩƷ
//		instance.setHandle(new QiXieShouJian());//��е�ܼ�Ŀ¼
//		instance.setHandle(new GSP());//GSP��֤
//		instance.setHandle(new GMP());//GMP��֤
//		instance.setHandle(new MedicalFactory());//ҩƷ�����ҵ
//		instance.setHandle(new LogoutDemostic());//ע�������׼�ĺŹ��ҩƷ

		//ҩƷ��Ӫ��ҵ excel has problem
		//ҩƷע�Ჹ�����뱸����� excel has problem
//		instance.setHandle(new DomesticMed());//���ҩƷ���Ե�16������Ѿ�ok
//		instance.setHandle(new DomesticMed());//���ҩƷ large ok
//		instance.setHandle(new GuoChanQiXie());//���ҽ����е outOfMemory ok
//		instance.setHandle(new .());//���ҽ����е outOfMemory
//		instance.setHandle(new ImportCosmetic());//��ڻ�ױƷ outOfMemory
		
		instance.startTransfer();
	}

}